create or replace procedure PRC_MB_NOTICESENDRESULT(PRM_MSG IN VARCHAR2 , PRM_RESULT IN VARCHAR2) is
s_msgid varchar2(20);
begin
  s_msgid := substr( prm_msg, 10,10 );
  INSERT INTO TMP_MSG VALUES(  'NOTICE' , PRM_MSG ||'$$' || PRM_RESULT , SYSDATE , s_msgid );
end PRC_MB_NOTICESENDRESULT;
/
